Skip to main content

Google Sheets

Please read the Material Usage Rules on this site.

Creating a Google Sheet:​

Using ProjectMaker.​

  • From the context menu: Add Action → Tables → Google Sheet:

Via ProjectMaker

  • Through the Static Blocks Panel:

Via ProjectMaker

The sheet you created will show up in the bottom panel:

Via ProjectMaker

Through the cloud.​

Go to Google.com → sign in to your account → click the icon with 9 dots → pick Sheets → create a Blank sheet.

Via ProjectMaker Via ProjectMaker

Or through Google Drive → Create → Google Sheets → Create blank spreadsheet.

Via ProjectMaker

After you create a sheet any way you like, copy the URL from the address bar to link it with ProjectMaker.

Sheet settings.​

Via ProjectMaker

Connection.

You need to connect Google Sheets to the program before you start using them. We’ll go over how to do this in the next article Setting up Google Sheets connection.

Let’s go over each section in detail:​

Paste the link (URL) for the sheet you want to work with in this field.

Reload Google Sheet.​

Via ProjectMaker

Click this button to refresh the data in the sheet.

Why do you need this?

This can be useful if you changed something not through the program but in a browser or on another device.

Google Sheet preview.​

In this window you’ll see your sheet’s data. If it’s large, you might not see all the data here, just part of it.

Save sheet changes to the cloud.​

Check this box if you want to save every change you make through ZennoDroid to the cloud.

First row as headers.​

The first row in your sheet will become the header.

Use atomic row append.​

Turning this on might be handy if you’re working with several copies of ZennoDroid at once. You can read more about atomic row appending in Operations and Multithreaded Work with Google Sheets.

Remember frozen rows and columns.​

This option lets you save the frozen state of rows and columns. It will send an extra request to the API, which uses up your limit.

Row separator.​

Here you choose what will be used as the row separator in your sheet:

  • New Line
  • Custom Separator
  • Multiple Separators

Column separator.​

Here, you set the separator for your sheet’s columns:

  • The ; character
  • Tab character
  • Any custom separator
  • Multiple custom separators

View content.​

This button opens the sheet so you can look at everything inside. In the window you can turn on control character display, set a filter to search for a specific row or cell, or use the filter builder.

Via ProjectMaker

Some quirks of working with Google Sheets.​

  • Every time you start a new project in the program, a virtual copy of the Google Sheet is made.
  • The virtual copy has all the data from the original sheet.
  • During the project, you work with the virtual copy.
  • If you turn on Save sheet changes to the cloud, the data will be updated from the virtual copy to the original Google Sheet from time to time.
Data in the Google Sheet doesn't show up instantly — it takes anywhere from 10 to 60 seconds.